package com.ztesoft.web.baseconfig.db.arg;

import java.util.*;
import java.math.*;
import org.apache.commons.lang.*;

public class DmTargetTableArg {
    private String pk_name = "TARGET_DATA_ID";

    private String orderByClause;

    private String groupByClause;

    private String columns;

    private String countsql1;

    private String countsql2;

    private boolean distinct;

    private int rowStart = 0;

    private int rowEnd = 10;

    private List<DmTargetTableCriteria> oredCriteria;

    public DmTargetTableArg() {
        oredCriteria = new ArrayList<DmTargetTableCriteria>();
    }

    public void setPk_name(String pk_name) {
        this.pk_name = StringEscapeUtils.escapeSql(pk_name);
    }

    public String getPk_name() {
        return pk_name;
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = StringEscapeUtils.escapeSql(orderByClause);
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setGroupByClause(String groupByClause) {
        this.groupByClause = StringEscapeUtils.escapeSql(groupByClause);
    }

    public String geGroupByClause() {
        return groupByClause;
    }

    public void setColumns(String columns) {
        this.columns = StringEscapeUtils.escapeSql(columns);
    }

    public String geColumns() {
        return columns;
    }

    public void setCountsql1(String countsql1) {
        this.countsql1 = StringEscapeUtils.escapeSql(countsql1);
    }

    public String geCountsql1() {
        return countsql1;
    }

    public void setCountsql2(String countsql2) {
        this.countsql2 = StringEscapeUtils.escapeSql(countsql2);
    }

    public String geCountsql2() {
        return countsql2;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public void setRowStart(int rowStart) {
        this.rowStart = rowStart;
    }

    public void setRowEnd(int rowEnd) {
        this.rowEnd = rowEnd;
    }

    public int getRowStart() {
        return rowStart;
    }

    public int getRowEnd() {
        return rowEnd;
    }

    public List<DmTargetTableCriteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(DmTargetTableCriteria criteria) {
        oredCriteria.add(criteria);
    }

    public DmTargetTableCriteria or() {
    	DmTargetTableCriteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public DmTargetTableCriteria createCriteria() {
    	DmTargetTableCriteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected DmTargetTableCriteria createCriteriaInternal() {
    	DmTargetTableCriteria criteria = new DmTargetTableCriteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        groupByClause = null;
        columns = null;
        countsql1 = null;
        countsql2 = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<DmTargetTableCriterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<DmTargetTableCriterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<DmTargetTableCriterion> getAllCriteria() {
            return criteria;
        }

        public List<DmTargetTableCriterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new DmTargetTableCriterion(condition));
        }

        protected void addCriterion(String condition, Object value,
                String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmTargetTableCriterion(condition, value));
        }

        protected void addCriterion(String condition, Object value,
                String property, int likeType) {
            if (value == null) {
                throw new RuntimeException("Value for " + property
                        + " cannot be null");
            }
            criteria.add(new DmTargetTableCriterion(condition, value, likeType));
        }

        protected void addCriterion(String condition, Object value1,
                Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property
                        + " cannot be null");
            }
            criteria.add(new DmTargetTableCriterion(condition, value1, value2));
        }

        public DmTargetTableCriteria andCriterionEqualTo(String criterion) {
            if (StringUtils.isBlank(criterion)) {
                criterion = "1=1";
            }
            addCriterion(criterion);
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andTargetDataIdIsNull() {
            addCriterion("TARGET_DATA_ID is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdIsNotNull() {
            addCriterion("TARGET_DATA_ID is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdEqualTo(Integer value) {
            addCriterion("TARGET_DATA_ID =", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotEqualTo(Integer value) {
            addCriterion("TARGET_DATA_ID <>", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdGreaterThan(Integer value) {
            addCriterion("TARGET_DATA_ID >", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("TARGET_DATA_ID >=", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdLessThan(Integer value) {
            addCriterion("TARGET_DATA_ID <", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("TARGET_DATA_ID <=", value, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdLike(Integer value) {
            addCriterion("TARGET_DATA_ID like ", value, "TARGET_DATA_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotLike(Integer value) {
            addCriterion("TARGET_DATA_ID  not like ", value, "TARGET_DATA_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdLeftLike(Integer value) {
            addCriterion("TARGET_DATA_ID like ", value, "TARGET_DATA_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotLeftLike(Integer value) {
            addCriterion("TARGET_DATA_ID  not like ", value, "TARGET_DATA_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdRightLike(Integer value) {
            addCriterion("TARGET_DATA_ID like ", value, "TARGET_DATA_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotRightLike(Integer value) {
            addCriterion("TARGET_DATA_ID  not like ", value, "TARGET_DATA_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdIn(List<Integer> values) {
            addCriterion("TARGET_DATA_ID  in ", values, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotIn(List<Integer> values) {
            addCriterion("TARGET_DATA_ID not in ", values, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdBetween(Integer value1, Integer value2) {
            addCriterion("TARGET_DATA_ID between ", value1, value2, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTargetDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("TARGET_DATA_ID not between ", value1, value2, "TARGET_DATA_ID");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andSourceDataIdIsNull() {
            addCriterion("SOURCE_DATA_ID is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdIsNotNull() {
            addCriterion("SOURCE_DATA_ID is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID =", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <>", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdGreaterThan(Integer value) {
            addCriterion("SOURCE_DATA_ID >", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID >=", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdLessThan(Integer value) {
            addCriterion("SOURCE_DATA_ID <", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdLessThanOrEqualTo(Integer value) {
            addCriterion("SOURCE_DATA_ID <=", value, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotLeftLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID like ", value, "SOURCE_DATA_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotRightLike(Integer value) {
            addCriterion("SOURCE_DATA_ID  not like ", value, "SOURCE_DATA_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID  in ", values, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotIn(List<Integer> values) {
            addCriterion("SOURCE_DATA_ID not in ", values, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID between ", value1, value2, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSourceDataIdNotBetween(Integer value1, Integer value2) {
            addCriterion("SOURCE_DATA_ID not between ", value1, value2, "SOURCE_DATA_ID");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andSeqNbrIsNull() {
            addCriterion("SEQ_NBR is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrIsNotNull() {
            addCriterion("SEQ_NBR is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrEqualTo(Integer value) {
            addCriterion("SEQ_NBR =", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotEqualTo(Integer value) {
            addCriterion("SEQ_NBR <>", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrGreaterThan(Integer value) {
            addCriterion("SEQ_NBR >", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrGreaterThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR >=", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrLessThan(Integer value) {
            addCriterion("SEQ_NBR <", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrLessThanOrEqualTo(Integer value) {
            addCriterion("SEQ_NBR <=", value, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrLeftLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotLeftLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrRightLike(Integer value) {
            addCriterion("SEQ_NBR like ", value, "SEQ_NBR", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotRightLike(Integer value) {
            addCriterion("SEQ_NBR  not like ", value, "SEQ_NBR", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrIn(List<Integer> values) {
            addCriterion("SEQ_NBR  in ", values, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotIn(List<Integer> values) {
            addCriterion("SEQ_NBR not in ", values, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR between ", value1, value2, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSeqNbrNotBetween(Integer value1, Integer value2) {
            addCriterion("SEQ_NBR not between ", value1, value2, "SEQ_NBR");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andDbLinkIdIsNull() {
            addCriterion("DB_LINK_ID is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdIsNotNull() {
            addCriterion("DB_LINK_ID is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdEqualTo(Integer value) {
            addCriterion("DB_LINK_ID =", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotEqualTo(Integer value) {
            addCriterion("DB_LINK_ID <>", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdGreaterThan(Integer value) {
            addCriterion("DB_LINK_ID >", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("DB_LINK_ID >=", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdLessThan(Integer value) {
            addCriterion("DB_LINK_ID <", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdLessThanOrEqualTo(Integer value) {
            addCriterion("DB_LINK_ID <=", value, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdLeftLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotLeftLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdRightLike(Integer value) {
            addCriterion("DB_LINK_ID like ", value, "DB_LINK_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotRightLike(Integer value) {
            addCriterion("DB_LINK_ID  not like ", value, "DB_LINK_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdIn(List<Integer> values) {
            addCriterion("DB_LINK_ID  in ", values, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotIn(List<Integer> values) {
            addCriterion("DB_LINK_ID not in ", values, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdBetween(Integer value1, Integer value2) {
            addCriterion("DB_LINK_ID between ", value1, value2, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andDbLinkIdNotBetween(Integer value1, Integer value2) {
            addCriterion("DB_LINK_ID not between ", value1, value2, "DB_LINK_ID");
            return (DmTargetTableCriteria) this;
        }
        
        public DmTargetTableCriteria andDbUserNameEqualTo(String value) {
            addCriterion("db_user_name =", value, "db_user_name");
            return (DmTargetTableCriteria) this;
        }
        
        public DmTargetTableCriteria andTableNameIsNull() {
            addCriterion("TABLE_NAME is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameIsNotNull() {
            addCriterion("TABLE_NAME is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameEqualTo(String value) {
            addCriterion("TABLE_NAME =", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotEqualTo(String value) {
            addCriterion("TABLE_NAME <>", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameGreaterThan(String value) {
            addCriterion("TABLE_NAME >", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameGreaterThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME >=", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameLessThan(String value) {
            addCriterion("TABLE_NAME <", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameLessThanOrEqualTo(String value) {
            addCriterion("TABLE_NAME <=", value, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameLeftLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotLeftLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameRightLike(String value) {
            addCriterion("TABLE_NAME like ", value, "TABLE_NAME", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotRightLike(String value) {
            addCriterion("TABLE_NAME  not like ", value, "TABLE_NAME", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameIn(List<String> values) {
            addCriterion("TABLE_NAME  in ", values, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotIn(List<String> values) {
            addCriterion("TABLE_NAME not in ", values, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameBetween(String value1, String value2) {
            addCriterion("TABLE_NAME between ", value1, value2, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andTableNameNotBetween(String value1, String value2) {
            addCriterion("TABLE_NAME not between ", value1, value2, "TABLE_NAME");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andSubFlagIsNull() {
            addCriterion("SUB_FLAG is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagIsNotNull() {
            addCriterion("SUB_FLAG is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagEqualTo(String value) {
            addCriterion("SUB_FLAG =", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotEqualTo(String value) {
            addCriterion("SUB_FLAG <>", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagGreaterThan(String value) {
            addCriterion("SUB_FLAG >", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagGreaterThanOrEqualTo(String value) {
            addCriterion("SUB_FLAG >=", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagLessThan(String value) {
            addCriterion("SUB_FLAG <", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagLessThanOrEqualTo(String value) {
            addCriterion("SUB_FLAG <=", value, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagLeftLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotLeftLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagRightLike(String value) {
            addCriterion("SUB_FLAG like ", value, "SUB_FLAG", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotRightLike(String value) {
            addCriterion("SUB_FLAG  not like ", value, "SUB_FLAG", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagIn(List<String> values) {
            addCriterion("SUB_FLAG  in ", values, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotIn(List<String> values) {
            addCriterion("SUB_FLAG not in ", values, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagBetween(String value1, String value2) {
            addCriterion("SUB_FLAG between ", value1, value2, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andSubFlagNotBetween(String value1, String value2) {
            addCriterion("SUB_FLAG not between ", value1, value2, "SUB_FLAG");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andOneRecordSizeIsNull() {
            addCriterion("ONE_RECORD_SIZE is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeIsNotNull() {
            addCriterion("ONE_RECORD_SIZE is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE =", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE <>", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeGreaterThan(Integer value) {
            addCriterion("ONE_RECORD_SIZE >", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeGreaterThanOrEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE >=", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeLessThan(Integer value) {
            addCriterion("ONE_RECORD_SIZE <", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeLessThanOrEqualTo(Integer value) {
            addCriterion("ONE_RECORD_SIZE <=", value, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeLeftLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotLeftLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeRightLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE like ", value, "ONE_RECORD_SIZE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotRightLike(Integer value) {
            addCriterion("ONE_RECORD_SIZE  not like ", value, "ONE_RECORD_SIZE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeIn(List<Integer> values) {
            addCriterion("ONE_RECORD_SIZE  in ", values, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotIn(List<Integer> values) {
            addCriterion("ONE_RECORD_SIZE not in ", values, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeBetween(Integer value1, Integer value2) {
            addCriterion("ONE_RECORD_SIZE between ", value1, value2, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andOneRecordSizeNotBetween(Integer value1, Integer value2) {
            addCriterion("ONE_RECORD_SIZE not between ", value1, value2, "ONE_RECORD_SIZE");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andStaffIdIsNull() {
            addCriterion("STAFF_ID is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdIsNotNull() {
            addCriterion("STAFF_ID is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdEqualTo(Integer value) {
            addCriterion("STAFF_ID =", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotEqualTo(Integer value) {
            addCriterion("STAFF_ID <>", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdGreaterThan(Integer value) {
            addCriterion("STAFF_ID >", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdGreaterThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID >=", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdLessThan(Integer value) {
            addCriterion("STAFF_ID <", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdLessThanOrEqualTo(Integer value) {
            addCriterion("STAFF_ID <=", value, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdLeftLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotLeftLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdRightLike(Integer value) {
            addCriterion("STAFF_ID like ", value, "STAFF_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotRightLike(Integer value) {
            addCriterion("STAFF_ID  not like ", value, "STAFF_ID", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdIn(List<Integer> values) {
            addCriterion("STAFF_ID  in ", values, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotIn(List<Integer> values) {
            addCriterion("STAFF_ID not in ", values, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID between ", value1, value2, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStaffIdNotBetween(Integer value1, Integer value2) {
            addCriterion("STAFF_ID not between ", value1, value2, "STAFF_ID");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andStateIsNull() {
            addCriterion("STATE is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateIsNotNull() {
            addCriterion("STATE is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateEqualTo(String value) {
            addCriterion("STATE =", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotEqualTo(String value) {
            addCriterion("STATE <>", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateGreaterThan(String value) {
            addCriterion("STATE >", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE >=", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateLessThan(String value) {
            addCriterion("STATE <", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateLessThanOrEqualTo(String value) {
            addCriterion("STATE <=", value, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateLike(String value) {
            addCriterion("STATE like ", value, "STATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateLeftLike(String value) {
            addCriterion("STATE like ", value, "STATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotLeftLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateRightLike(String value) {
            addCriterion("STATE like ", value, "STATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotRightLike(String value) {
            addCriterion("STATE  not like ", value, "STATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateIn(List<String> values) {
            addCriterion("STATE  in ", values, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotIn(List<String> values) {
            addCriterion("STATE not in ", values, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateBetween(String value1, String value2) {
            addCriterion("STATE between ", value1, value2, "STATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateNotBetween(String value1, String value2) {
            addCriterion("STATE not between ", value1, value2, "STATE");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andStateDateIsNull() {
            addCriterion("STATE_DATE is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateIsNotNull() {
            addCriterion("STATE_DATE is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateEqualTo(String value) {
            addCriterion("STATE_DATE =", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotEqualTo(String value) {
            addCriterion("STATE_DATE <>", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateGreaterThan(String value) {
            addCriterion("STATE_DATE >", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateGreaterThanOrEqualTo(String value) {
            addCriterion("STATE_DATE >=", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateLessThan(String value) {
            addCriterion("STATE_DATE <", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateLessThanOrEqualTo(String value) {
            addCriterion("STATE_DATE <=", value, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateLeftLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotLeftLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateRightLike(String value) {
            addCriterion("STATE_DATE like ", value, "STATE_DATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotRightLike(String value) {
            addCriterion("STATE_DATE  not like ", value, "STATE_DATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateIn(List<String> values) {
            addCriterion("STATE_DATE  in ", values, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotIn(List<String> values) {
            addCriterion("STATE_DATE not in ", values, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateBetween(String value1, String value2) {
            addCriterion("STATE_DATE between ", value1, value2, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andStateDateNotBetween(String value1, String value2) {
            addCriterion("STATE_DATE not between ", value1, value2, "STATE_DATE");
            return (DmTargetTableCriteria) this;
        }
        public DmTargetTableCriteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateEqualTo(String value) {
            addCriterion("CREATE_DATE =", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotEqualTo(String value) {
            addCriterion("CREATE_DATE <>", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateGreaterThan(String value) {
            addCriterion("CREATE_DATE >", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE >=", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateLessThan(String value) {
            addCriterion("CREATE_DATE <", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateLessThanOrEqualTo(String value) {
            addCriterion("CREATE_DATE <=", value, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 1);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateLeftLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotLeftLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 0);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateRightLike(String value) {
            addCriterion("CREATE_DATE like ", value, "CREATE_DATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotRightLike(String value) {
            addCriterion("CREATE_DATE  not like ", value, "CREATE_DATE", 2);
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateIn(List<String> values) {
            addCriterion("CREATE_DATE  in ", values, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotIn(List<String> values) {
            addCriterion("CREATE_DATE not in ", values, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateBetween(String value1, String value2) {
            addCriterion("CREATE_DATE between ", value1, value2, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

        public DmTargetTableCriteria andCreateDateNotBetween(String value1, String value2) {
            addCriterion("CREATE_DATE not between ", value1, value2, "CREATE_DATE");
            return (DmTargetTableCriteria) this;
        }

    }

    public static class DmTargetTableCriteria extends GeneratedCriteria {

        protected DmTargetTableCriteria() {
            super();
        }
    }

    public static class DmTargetTableCriterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected DmTargetTableCriterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }
        protected DmTargetTableCriterion(String condition, Object value, int likeType) {
            this.condition = condition;
            if (likeType == 0) {
                this.value = "%" + value;
            }
            else if (likeType == 1) {
                this.value = "%" + value + "%";
            }
            else {
                this.value = value + "%";
            }
            this.typeHandler = null;
            this.singleValue = true;

        }

        protected DmTargetTableCriterion(String condition, Object value,
                String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            }
            else {
                this.singleValue = true;
            }
        }

        protected DmTargetTableCriterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected DmTargetTableCriterion(String condition, Object value,
                Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected DmTargetTableCriterion(String condition, Object value,
                Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}